{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","2-Wheelers TCO Dashboard","Summary","Currency","Capital Cost","Financing","Operational Cost","TCO_1","References","Tech. Specs."],"not_rendered":{"charts":5,"images":13,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[9,1,9,3],[9,5,9,13],[1,1,1,13],[3,1,3,13],[5,1,5,8],[8,1,8,3],[8,5,8,13],[16,1,16,3],[16,5,16,13],[10,1,10,3],[10,5,10,13],[11,1,11,3],[11,5,13,13],[12,1,12,3],[14,1,14,13],[15,1,15,3],[15,5,15,13],[23,1,23,3],[23,5,23,13],[17,1,17,3],[17,5,17,13],[18,1,18,3],[18,5,18,13],[19,1,19,3],[19,5,19,13],[20,1,20,3],[20,5,20,13],[21,1,21,3],[21,5,21,13],[22,1,22,13],[30,1,30,3],[30,5,30,13],[24,1,24,3],[24,5,24,13],[25,1,25,3],[25,5,25,13],[26,1,26,3],[26,5,26,13],[27,1,27,3],[27,5,27,13],[28,1,28,13],[29,1,29,3],[29,5,29,13],[31,1,31,3],[31,5,31,13],[32,1,32,3],[32,5,32,13],[33,1,33,3],[33,5,33,13],[41,1,42,14],[34,1,34,3],[34,5,34,13],[35,1,35,3],[35,5,35,13],[36,1,36,3],[36,5,36,13]]}
[]
[null,"HOW TO USE THE DYNAMIC TOTAL COST OF OWNERSHIP DASHBOARD"]
[]
[null,"All cells highlighted Green are Input cells. Values can only be edited in these cells to observe the dynamic changes in the dashboard on the right."]
[]
[null,"All cells highlighted Gray are Fixed cells. These values cannot be edited."]
[]
[]
[null,"CELL NAME",null,null,"FUNCTION","ACTION REQUIRED"]
[null,"Vehicle Holding Period (Year)",null,null,"Editable","Use the drop down menu on Cell C5 to choose the Vehicle holding period from 1 to 10 years "]
[null,"Daily Distance Travelled (km)",null,null,"Editable","Use the arrows on the right to increase/decrease to input Daily Distance Travelled in km"]
[null,"Daily Distance Travelled (mi)",null,null,"Fixed"]
[null,"Annual Distance Travelled (km)",null,null,"Fixed"]
[null,"Annual Distance Travelled (mi)",null,null,"Fixed"]
[]
[null,"Vehicle Purchase Cost",null,null,"Editable","Add number values to input the purchase cost of a 2-Wheeler"]
[null,"Tax",null,null,"Editable","Add number values to input Tax levied on the 2-Wheeler"]
[null,"Annual Insurance Cost",null,null,"Editable","Add number values to input Annual Insurance cost of the 2-Wheeler"]
[null,"Financial Incentive",null,null,"Editable","Add number values to input Total incentives including FAME subsidy & other miscellaneous incentives"]
[]
[null,"Discount Rate",null,null,"Editable","Add percentage values to input the present value of future cash flows at the end of holding period"]
[null,"Resale Rate",null,null,"Editable","Add percentage values to input the resale value of the 2-Wheeler at the end of holding period"]
[]
[null,"Terms of Payment",null,null,"Editable","Add number values to input the Total number of years of loan repayment"]
[null,"Interest Rate",null,null,"Editable","Add percentage values to input prevailing interest on 2-Wheeler Loans"]
[null,"Equity",null,null,"Editable","Add percentage values to input initial equity payment made for the purchase of the 2-Wheeler"]
[null,"Monthly EMI",null,null,"Fixed"]
[null,"Charging Infrastructure Cost",null,null,"Editable","Add number values to input the Total cost of Charging Infrastructure"]
[]
[null,"Staff cost per Month",null,null,"Editable","Add number values to input Total Staff cost incurred in a month"]
[null,"Lithium-Ion Battery Cost",null,null,"Editable","Add number values to input prevailing cost of Li-Ion battery in USD per kWh"]
[]
[null,"Fuel Cost",null,null,"Editable","Add number values to input Total cost per unit of Fuel (in associated fuel units) "]
[null,"Capacity of Battery",null,null,"Editable","Add number values to input capacity of battery for Electric 2-Wheeler in kWh"]
[null,"Number of Battery Replacements",null,null,"Editable","Add number values to input total number of battery replacements for Electric 2-Wheeler"]
[null,"Mileage",null,null,"Editable","Add number values to input mileage of different models of 2-Wheelers"]
[null,"Annual Maintenance Cost",null,null,"Editable","Add number values to input the Annual Maintenance cost of a 2-Wheeler"]
[]
[]
[null,"NOTES"]
[]
[null,"1. For more details regarding Methodology and TCO calculations, please refer to the research paper. Total Cost of Ownership Analysis of the Impact of Vehicle Usage on the Economic Viability of Electric Vehicles in India, P. Kumar and S. Chakrabarty Transport. Res. Rec., 2020 (1-10)"]

{"sheet":"2-Wheelers TCO Dashboard","index":1,"n_rows":74,"n_cols":47,"rows_kept":74,"cut":false,"hidden":false,"merged":[[2,1,2,3],[14,3,14,5],[16,2,16,5],[4,3,4,5]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dynamic","TCO",null,null,"e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (VRLA)",{"$f":"VLOOKUP($C$5,$AQ$2:$AU$12,2,0)","v":1.5123334676397666},null,1,{"$f":"IF($C$5=AQ3,AR20:AU20,)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (LIB_SB)",{"$f":"VLOOKUP($C$5,$AQ$2:$AU$12,3,0)","v":1.2088799145706186},null,2,{"$f":"IF($C$5=AQ4,AR21:AU21,)","v":0}]
[null,"Vehicle Holding Period (Year)",5,"              Use Drop down to choose Holding Period",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (LIB_BB)",{"$f":"VLOOKUP($C$5,$AQ$2:$AU$12,4,0)","v":1.8634166978044915},null,3,{"$f":"IF($C$5=AQ5,AR22:AU22,)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petrol-2W",{"$f":"VLOOKUP($C$5,$AQ$2:$AU$12,5,0)","v":2.8706016164965504},null,4,{"$f":"IF($C$5=AQ6,AR23:AU23,)","v":0}]
[null,"Daily Distance Travelled (km)",80,null,"(Use Arrows to input Distance)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF($C$5=AQ7,AR24:AU24,)","v":1.5123334676397666},1.2088799145706186,1.8634166978044915,2.8706016164965504]
[null,"Daily Distance Travelled (mi)",{"$f":"C7*0.621371","v":49.709679999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 10","TCO",null,6,{"$f":"IF($C$5=AQ8,AR25:AU25,)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (VRLA)",{"$f":"AR29","v":1.0930331893920329},null,7,{"$f":"IF($C$5=AQ9,AR26:AU26,)","v":0}]
[null,"Annual Distance Travelled (km)",{"$f":"C7*365","v":29200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (LIB_SB)",{"$f":"AS29","v":0.81516213895316914},null,8,{"$f":"IF($C$5=AQ10,AR27:AU27,)","v":0}]
[null,"Annual Distance Travelled (mi)",{"$f":"C8*365","v":18144.033199999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (LIB_BB)",{"$f":"AT29","v":1.2488268747984046},null,9,{"$f":"IF($C$5=AQ11,AR28:AU28,)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petrol-2W",{"$f":"AU29","v":2.1887615126390045},null,10,{"$f":"IF($C$5=AQ12,AR29:AU29,)","v":0}]
[]
[]
[null,null,"INR"]
[]
[]
[]
[null,"MODEL","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operational Years","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
[null,{"$f":"VLOOKUP($C$15,Currency!B17:C19,2,0)","v":"Vehicle Purchase Cost (₹)"},59889,81998,142190,66271,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",{"$f":"TCO_1!C31","v":3.9313567299586998},{"$f":"TCO_1!C34","v":4.1410960306968372},{"$f":"TCO_1!C37","v":6.6295030223315967},{"$f":"TCO_1!C40","v":5.6413682738651802}]
[null,{"$f":"VLOOKUP($C$15,Currency!B21:C23,2,0)","v":"Tax (₹)"},4192,4549,9055,4638,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2",{"$f":"TCO_1!D31","v":2.4699099644992391},{"$f":"TCO_1!D34","v":2.321014884048707},{"$f":"TCO_1!D37","v":3.6603427874236623},{"$f":"TCO_1!D40","v":4.0529295722061534}]
[null,{"$f":"VLOOKUP($C$15,Currency!B25:C27,2,0)","v":"Insurance cost (₹)"},1593,1680,2505,4418,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3",{"$f":"TCO_1!E31","v":1.9588456123923428},{"$f":"TCO_1!E34","v":1.7082822051050839},{"$f":"TCO_1!E37","v":2.6658898077472171},{"$f":"TCO_1!E40","v":3.4556676900943502}]
[null,{"$f":"VLOOKUP($C$15,Currency!B29:C31,2,0)","v":"Financial Incentive (₹)"},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 4",{"$f":"TCO_1!F31","v":1.6871000845447166},{"$f":"TCO_1!F34","v":1.3979162955109841},{"$f":"TCO_1!F37","v":2.1656292321324537},{"$f":"TCO_1!F40","v":3.1109177149551055}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 5",{"$f":"TCO_1!G31","v":1.5123334676397666},{"$f":"TCO_1!G34","v":1.2088799145706186},{"$f":"TCO_1!G37","v":1.8634166978044915},{"$f":"TCO_1!G40","v":2.8706016164965504}]
[null,"Discount Rate (%)",0.1,0.1,0.1,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 6",{"$f":"TCO_1!H31","v":1.3870026774891799},{"$f":"TCO_1!H34","v":1.0807962200445094},{"$f":"TCO_1!H37","v":1.6605058796907284},{"$f":"TCO_1!H40","v":2.6850985619564929}]
[null,"Resale Rate (%)",0.1,0.15,0.2,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 7",{"$f":"TCO_1!I31","v":1.2906568884097427},{"$f":"TCO_1!I34","v":0.98776510936814288},{"$f":"TCO_1!I37","v":1.5145522139077323},{"$f":"TCO_1!I40","v":2.5329386546069772}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 8",{"$f":"TCO_1!J31","v":1.2130108057815967},{"$f":"TCO_1!J34","v":0.9168171287937994},{"$f":"TCO_1!J37","v":1.4043636602724812},{"$f":"TCO_1!J40","v":2.4032247611013275}]
[null,{"$f":"VLOOKUP($C$15,Currency!B45:C47,2,0)","v":"Financing Component (₹)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 9",{"$f":"TCO_1!K31","v":1.148301951093506},{"$f":"TCO_1!K34","v":0.86073130085271221},{"$f":"TCO_1!K37","v":1.3181508205908157},{"$f":"TCO_1!K40","v":2.2897718218616645}]
[null,"Term of Payment (Years)",5,5,5,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 10",{"$f":"TCO_1!L31","v":1.0930331893920329},{"$f":"TCO_1!L34","v":0.81516213895316914},{"$f":"TCO_1!L37","v":1.2488268747984046},{"$f":"TCO_1!L40","v":2.1887615126390045}]
[null,"Interest Rate (%)",0.15,0.15,0.15,0.1]
[null,"Equity (%)",0.15,0.15,0.15,0.15]
[null,{"$f":"VLOOKUP($C$15,Currency!B49:C51,2,0)","v":"Monthly EMI (₹)"},{"$f":"Financing!B12","v":1219.3751878339808},{"$f":"Financing!C12","v":1666.4510174713901},{"$f":"Financing!D12","v":2885.3584267991127},{"$f":"Financing!E12","v":1205.1867983847242}]
[null,{"$f":"VLOOKUP($C$15,Currency!$B$53:$C$55,2,0)","v":"Charging Infrastructure Cost (₹)"},0,0,0]
[]
[]
[]
[]
[]
[]
[null,{"$f":"VLOOKUP($C$15,Currency!B33:C35,2,0)","v":"Staff Cost per Month (₹)"},0]
[null,"Lithium-Ion Battery Cost (USD/kWh)",137]
[]
[null,"MODEL","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
[null,{"$f":"VLOOKUP($C$15,Currency!B37:D39,2,0)","v":"Fuel cost (₹/kWh; ₹/L)"},6,6,6,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fixed cost",{"$f":"TCO_1!C10/TCO_1!C9","v":0.47118551638619932},{"$f":"TCO_1!D10/TCO_1!D9","v":0.62234406156122868},{"$f":"TCO_1!E10/TCO_1!E9","v":1.0596556124003393},{"$f":"TCO_1!F10/TCO_1!F9","v":0.48928145994222755}]
[null,"Capacity of Battery (kWh)",3.24,1.75,2.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Variable cost",{"$f":"TCO_1!L22/TCO_1!C9","v":0.62184767300583355},{"$f":"TCO_1!L23/TCO_1!D9","v":0.19281807739194054},{"$f":"TCO_1!L24/TCO_1!E9","v":0.18917126239806512},{"$f":"TCO_1!L25/TCO_1!F9","v":1.6994800526967768}]
[null,"Number of Battery Replacements",10,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total TCO",{"$f":"SUM(AR44:AR45)","v":1.0930331893920329},{"$f":"SUM(AS44:AS45)","v":0.81516213895316925},1.2488268747984044,2.1887615126390045]
[null,"Mileage (km/kWh; km/L)",52,57,59,38]
[null,{"$f":"VLOOKUP($C$15,Currency!B41:C43,2,0)","v":"Annual Maintenance Cost (₹)"},1250,1200,1200,2546]
[]
[]
[]
[]
[]
[null,"WORK NOTES"]
[]
[null,"1. Model Key",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Components","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
[null,"VRLA = Lead Acid Battery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed",{"$f":"Summary!B19","v":87930.861270038848},{"$f":"Summary!C19","v":118515.76104828341},{"$f":"Summary!D19","v":206010.00560794678},{"$f":"Summary!E19","v":91307.857903083437}]
[null,"LIB_SB =  Lithium-Ion Small Battery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance",{"$f":"Summary!B23","v":2530},{"$f":"Summary!C23","v":2589},{"$f":"Summary!D23","v":3620},{"$f":"Summary!E23","v":3920}]
[null,"LIB_BB = Lithium-Ion Big Battery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Battery Replacement",{"$f":"Summary!B24","v":23652},{"$f":"Summary!C24","v":3500.35},{"$f":"Summary!D24","v":2400.2399999999998},{"$f":"Summary!E24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel",{"$f":"Summary!B25","v":3369.2307692307695},{"$f":"Summary!C25","v":3073.6842105263158},{"$f":"Summary!D25","v":2969.4915254237289},{"$f":"Summary!E25","v":76842.105263157893}]
[null,"2. Financial Incentives can be added by referencing Department of Heavy Industry's website ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
[null,"https://fame2.heavyindustry.gov.in/ModelUnderFame.aspx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed Cost ",{"$f":"AR44/AR46","v":0.43108070364110557},{"$f":"AS44/AS46","v":0.76346045997725376},0.84852082685311958,0.22354260942403797]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Cost",{"$f":"AR45/AR46","v":0.56891929635889449},{"$f":"AS45/AS46","v":0.23653954002274616},0.15147917314688047,0.77645739057596197]
[null,"3. Additional Features like Sensitivity Analysis will be added in the next iteration of the model"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR62:AR66)","v":1},{"$f":"SUM(AS62:AS66)","v":0.99999999999999989},{"$f":"SUM(AT62:AT66)","v":1},{"$f":"SUM(AU62:AU66)","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (VRLA)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (LIB_SB)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-2W (LIB_BB)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petrol-2W"]

{"sheet":"Summary","index":2,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["TRAVEL DETAILS"]
["Number of Vehicle",1]
["Life of Vehicle (yrs)",10]
["Annual drive distance (KM)",{"$f":"'2-Wheelers TCO Dashboard'!C10","v":29200}]
["Total Distance Travel (KM)",{"$f":"B3*B4","v":292000}]
["LIB Cost (USD/kWh)",{"$f":"'2-Wheelers TCO Dashboard'!C41","v":137}]
["USD to INR",73]
["VRLA Cost (USD/kWh)",100]
["General Inputs","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["Discount rate (%)",{"$f":"'2-Wheelers TCO Dashboard'!C25","v":0.1},{"$f":"'2-Wheelers TCO Dashboard'!D25","v":0.1},{"$f":"'2-Wheelers TCO Dashboard'!E25","v":0.1},{"$f":"'2-Wheelers TCO Dashboard'!F25","v":0.1}]
["Resale rate (%)",{"$f":"'2-Wheelers TCO Dashboard'!C26","v":0.1},{"$f":"'2-Wheelers TCO Dashboard'!D26","v":0.15},{"$f":"'2-Wheelers TCO Dashboard'!E26","v":0.2},{"$f":"'2-Wheelers TCO Dashboard'!F26","v":0.1}]
[]
["Capital Cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["Total Vehicle Cost (₹)",{"$f":"'Capital Cost'!B8","v":87930.861270038848},{"$f":"'Capital Cost'!C8","v":118515.76104828341},{"$f":"'Capital Cost'!D8","v":206010.00560794678},{"$f":"'Capital Cost'!E8","v":91307.857903083437}]
["Resale Value (₹)",{"$f":"B14*B11","v":8793.0861270038858},{"$f":"C14*C11","v":17777.364157242511},{"$f":"D14*D11","v":41202.001121589361},{"$f":"E14*E11","v":9130.7857903083441}]
["Total Charging Infrastructure Cost (₹)",{"$f":"'2-Wheelers TCO Dashboard'!C33","v":0},{"$f":"'2-Wheelers TCO Dashboard'!D33","v":0},{"$f":"'2-Wheelers TCO Dashboard'!E33","v":0},{"$f":"'2-Wheelers TCO Dashboard'!F33","v":0}]
["Misc. Cost (₹)",0,0,0,0]
["Financial Incentive (₹)",{"$f":"'2-Wheelers TCO Dashboard'!C23","v":0},{"$f":"'2-Wheelers TCO Dashboard'!D23","v":0},{"$f":"'2-Wheelers TCO Dashboard'!E23","v":0}]
["Total Capital Cost (₹) excl. Resale Value",{"$f":"(B14+B16+B17)-B18","v":87930.861270038848},{"$f":"(C14+C16+C17)-C18","v":118515.76104828341},206010.00560794678,91307.857903083437]
[]
["Annual Operational Cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["Staff Cost (₹)",{"$f":"'Operational Cost'!B4","v":0},{"$f":"'Operational Cost'!C4","v":0},{"$f":"'Operational Cost'!D4","v":0},{"$f":"'Operational Cost'!E4","v":0}]
["Maintenance Cost (₹)",{"$f":"'Operational Cost'!B18","v":2530},{"$f":"'Operational Cost'!C18","v":2589},{"$f":"'Operational Cost'!D18","v":3620},{"$f":"'Operational Cost'!E18","v":3920}]
["Battery Replacement Cost (₹)*",{"$f":"'Operational Cost'!B27/B3","v":23652},{"$f":"'Operational Cost'!C27/B3","v":3500.35},{"$f":"'Operational Cost'!D27/B3","v":2400.2399999999998}]
["Average Fuel Cost (₹)",{"$f":"'Operational Cost'!B11","v":3369.2307692307695},{"$f":"'Operational Cost'!C11","v":3073.6842105263158},{"$f":"'Operational Cost'!D11","v":2969.4915254237289},{"$f":"'Operational Cost'!E11","v":76842.105263157893}]
["Misc. Cost (₹)",0,0,0,0]
["Total Operational Cost (₹)",{"$f":"(SUM(B22:B26))","v":29551.23076923077},{"$f":"(SUM(C22:C26))","v":9163.0342105263153},{"$f":"(SUM(D22:D26))","v":8989.7315254237292},{"$f":"(SUM(E22:E26))","v":80762.105263157893}]
[]
["Total Operational Cost for life of 2W",{"$f":"B27*$B$3","v":295512.30769230769},{"$f":"C27*$B$3","v":91630.342105263146},{"$f":"D27*$B$3","v":89897.315254237299},{"$f":"E27*$B$3","v":807621.05263157887}]
["Average TCO",{"$f":"TCO_1!C11","v":1.0930331893920329},{"$f":"TCO_1!D11","v":0.81516213895316914},{"$f":"TCO_1!E11","v":1.2488268747984046},{"$f":"TCO_1!F11","v":2.1887615126390045}]

{"sheet":"Currency","index":3,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":true,"merged":[[15,1,15,2],[1,1,1,3],[15,4,15,5],[15,7,15,8]]}
[]
[null,"CURRENCY CONVERSION"]
[]
[null,"USD","INR","Conversion"]
[null,1,74,{"$f":"B5*C5","v":74}]
[]
[null,"EURO","INR","Conversion"]
[null,1,82,{"$f":"B8*C8","v":82}]
[]
[]
[]
[]
[]
[]
[]
[null,"DROP DOWN",null,null,"DASHBOARD TITLE",null,null,"DASHBOARD TITLE 2"]
[null,"INR",{"$f":"IF(B17='2-Wheelers TCO Dashboard'!$C$15,\"Vehicle Purchase Cost (₹)\",\"\")","v":"Vehicle Purchase Cost (₹)"},null,"INR",{"$f":"IF(E17='2-Wheelers TCO Dashboard'!$C$15,\"TCO BY MODELS AT YEAR 10 (₹ / km)\",\"\")","v":"TCO BY MODELS AT YEAR 10 (₹ / km)"},null,1,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H17,\"TCO AT YEAR 1\",\"\")","v":""}]
[null,"USD",{"$f":"IF(B18='2-Wheelers TCO Dashboard'!$C$15,\"Vehicle Purchase Cost ($)\",\"\")","v":""},null,"USD",{"$f":"IF(E18='2-Wheelers TCO Dashboard'!$C$15,\"TCO BY MODELS AT YEAR 10 ($ / mi)\",\"\")","v":""},null,2,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H18,\"TCO AT YEAR 2\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B19='2-Wheelers TCO Dashboard'!$C$15,\"Vehicle Purchase Cost (€)\",\"\")","v":""},null,"EURO",{"$f":"IF(E19='2-Wheelers TCO Dashboard'!$C$15,\"TCO BY MODEL AT YEAR 10 (€ / km)\",\"\")","v":""},null,3,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H19,\"TCO AT YEAR 3\",\"\")","v":""}]
[null,null,null,null,null,null,null,4,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H20,\"TCO AT YEAR 4\",\"\")","v":""}]
[null,"INR",{"$f":"IF(B21='2-Wheelers TCO Dashboard'!$C$15,\"Tax (₹)\",\"\")","v":"Tax (₹)"},null,"INR",{"$f":"IF(E21='2-Wheelers TCO Dashboard'!$C$15,\"TCO BREAKDOWN BY COST AT YEAR 10 (₹ / km)\",\"\")","v":"TCO BREAKDOWN BY COST AT YEAR 10 (₹ / km)"},null,5,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H21,\"TCO AT YEAR 5\",\"\")","v":"TCO AT YEAR 5"}]
[null,"USD",{"$f":"IF(B22='2-Wheelers TCO Dashboard'!$C$15,\"Tax ($)\",\"\")","v":""},null,"USD",{"$f":"IF(E22='2-Wheelers TCO Dashboard'!$C$15,\"TCO BREAKDOWN BY COST AT YEAR 10 ($ / mi)\",\"\")","v":""},null,6,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H22,\"TCO AT YEAR 6\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B23='2-Wheelers TCO Dashboard'!$C$15,\"Tax (€)\",\"\")","v":""},null,"EURO",{"$f":"IF(E23='2-Wheelers TCO Dashboard'!$C$15,\"TCO BREAKDOWN BY COST AT YEAR 10 (€ / km)\",\"\")","v":""},null,7,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H23,\"TCO AT YEAR 7\",\"\")","v":""}]
[null,null,null,null,null,null,null,8,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H24,\"TCO AT YEAR 8\",\"\")","v":""}]
[null,"INR",{"$f":"IF(B25='2-Wheelers TCO Dashboard'!$C$15,\"Insurance cost (₹)\",\"\")","v":"Insurance cost (₹)"},null,"INR",{"$f":"IF(E25='2-Wheelers TCO Dashboard'!$C$15,\"TOTAL COST OF OWNERSHIP OVER YEARS (₹ / km)\",\"\")","v":"TOTAL COST OF OWNERSHIP OVER YEARS (₹ / km)"},null,9,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H25,\"TCO AT YEAR 9\",\"\")","v":""}]
[null,"USD",{"$f":"IF(B26='2-Wheelers TCO Dashboard'!$C$15,\"Insurance Cost ($)\",\"\")","v":""},null,"USD",{"$f":"IF(E26='2-Wheelers TCO Dashboard'!$C$15,\"TOTAL COST OF OWNERSHIP OVER YEARS ($ / mi)\",\"\")","v":""},null,10,{"$f":"IF('2-Wheelers TCO Dashboard'!C$5=H26,\"TCO AT YEAR 10\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B27='2-Wheelers TCO Dashboard'!$C$15,\"Insurance Cost (€)\",\"\")","v":""},null,"EURO",{"$f":"IF(E27='2-Wheelers TCO Dashboard'!$C$15,\"TOTAL COST OF OWNERSHIP OVER YEARS (€ / km)\",\"\")","v":""}]
[]
[null,"INR",{"$f":"IF(B29='2-Wheelers TCO Dashboard'!$C$15,\"Financial Incentive (₹)\",\"\")","v":"Financial Incentive (₹)"}]
[null,"USD",{"$f":"IF(B30='2-Wheelers TCO Dashboard'!$C$15,\"Financial Incentive ($)\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B31='2-Wheelers TCO Dashboard'!$C$15,\"Financial Incentive (€)\",\"\")","v":""}]
[]
[null,"INR",{"$f":"IF(B33='2-Wheelers TCO Dashboard'!$C$15,\"Staff Cost per Month (₹)\",\"\")","v":"Staff Cost per Month (₹)"}]
[null,"USD",{"$f":"IF(B34='2-Wheelers TCO Dashboard'!$C$15,\"Staff Cost per Month ($)\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B35='2-Wheelers TCO Dashboard'!$C$15,\"Staff Cost per Month (€)\",\"\")","v":""}]
[]
[null,"INR",{"$f":"IF(B37='2-Wheelers TCO Dashboard'!$C$15,\"Fuel cost (₹/kWh; ₹/L)\",\"\")","v":"Fuel cost (₹/kWh; ₹/L)"}]
[null,"USD",{"$f":"IF(B38='2-Wheelers TCO Dashboard'!$C$15,\"Fuel cost ($/kWh; $/gal)\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B39='2-Wheelers TCO Dashboard'!$C$15,\"Fuel cost (€/kWh; €/L)\",\"\")","v":""}]
[]
[null,"INR",{"$f":"IF(B41='2-Wheelers TCO Dashboard'!$C$15,\"Annual Maintenance Cost (₹)\",\"\")","v":"Annual Maintenance Cost (₹)"}]
[null,"USD",{"$f":"IF(B42='2-Wheelers TCO Dashboard'!$C$15,\"Annual Maintenance Cost ($)\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B43='2-Wheelers TCO Dashboard'!$C$15,\"Annual Maintenance Cost (€)\",\"\")","v":""}]
[]
[null,"INR",{"$f":"IF(B45='2-Wheelers TCO Dashboard'!$C$15,\"Financing Component (₹)\",\"\")","v":"Financing Component (₹)"}]
[null,"USD",{"$f":"IF(B46='2-Wheelers TCO Dashboard'!$C$15,\"Financing Component ($)\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B47='2-Wheelers TCO Dashboard'!$C$15,\"Financing Component (€)\",\"\")","v":""}]
[]
[null,"INR",{"$f":"IF(B49='2-Wheelers TCO Dashboard'!$C$15,\"Monthly EMI (₹)\",\"\")","v":"Monthly EMI (₹)"}]
[null,"USD",{"$f":"IF(B50='2-Wheelers TCO Dashboard'!$C$15,\"Monthly EMI ($)\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B51='2-Wheelers TCO Dashboard'!$C$15,\"Monthly EMI (€)\",\"\")","v":""}]
[]
[null,"INR",{"$f":"IF(B53='2-Wheelers TCO Dashboard'!$C$15,\"Charging Infrastructure Cost (₹)\",\"\")","v":"Charging Infrastructure Cost (₹)"}]
[null,"USD",{"$f":"IF(B54='2-Wheelers TCO Dashboard'!$C$15,\"Charging Infrastructure Cost ($)\",\"\")","v":""}]
[null,"EURO",{"$f":"IF(B55='2-Wheelers TCO Dashboard'!$C$15,\"Charging Infrastructure Cost (€)\",\"\")","v":""}]

{"sheet":"Capital Cost","index":4,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":true,"merged":[[23,0,23,4],[28,0,28,4],[33,0,33,4],[38,0,38,4]]}
["Vehicle Cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W",null,"USER INPUT"]
["Purchase Cost (₹)",{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$25:$E$27,2,0)","v":59889},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$25:$E$27,3,0)","v":81998},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$25:$E$27,4,0)","v":142190},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$25:$E$27,5,0)","v":66271},null,"PREFIXED DATA"]
["Tax (₹)",{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$30:$E$32,2,0)","v":4192},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$30:$E$32,3,0)","v":4549},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$30:$E$32,4,0)","v":9055},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$30:$E$32,5,0)","v":4638},null,"CALCULATION"]
["Insurance (₹)",{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$35:$E$37,2,0)","v":1593},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$35:$E$37,3,0)","v":1680},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$35:$E$37,4,0)","v":2505},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$35:$E$37,5,0)","v":4418},null,"LINKED CELL"]
["Financing Component (₹)",{"$f":"Financing!B17","v":22256.86127003884},{"$f":"Financing!C17","v":30288.761048283413},{"$f":"Financing!D17","v":52260.005607946776},{"$f":"Financing!E17","v":15980.857903083444}]
["Total Financial Incentive (₹)",{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$40:$E$42,2,0)","v":0},0,0,{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Capital Cost'!$A$40:$E$42,5,0)","v":0}]
["Misc. Cost (₹)",0,0,0,0]
["Total Vehicle Cost (₹)",{"$f":"((B2+B3+B4+B5+B7)-B6)","v":87930.861270038848},{"$f":"((C2+C3+C4+C5+C7)-C6)","v":118515.76104828341},{"$f":"((D2+D3+D4+D5+D7)-D6)","v":206010.00560794678},{"$f":"((E2+E3+E4+E5+E7)-E6)","v":91307.857903083437}]
[]
["Charging Infrastructure Cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["No. of Slow Charger (SC)",{"$f":"'2-Wheelers TCO Dashboard'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2-Wheelers TCO Dashboard'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2-Wheelers TCO Dashboard'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2-Wheelers TCO Dashboard'!#REF!","v":{"$error":"#REF!"}}]
["Cost of SC per unit (₹)",0,0,0,0]
["Total Cost of SC (₹)",{"$f":"B11*B12","v":{"$error":"#REF!"}},{"$f":"C11*C12","v":{"$error":"#REF!"}},{"$f":"D11*D12","v":{"$error":"#REF!"}},0]
["No. of Fast Charger (FC)",{"$f":"'2-Wheelers TCO Dashboard'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2-Wheelers TCO Dashboard'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2-Wheelers TCO Dashboard'!#REF!","v":{"$error":"#REF!"}},{"$f":"'2-Wheelers TCO Dashboard'!#REF!","v":{"$error":"#REF!"}}]
["Cost of FC per unit (₹)",0,0,0,0]
["Total Cost of FC (₹)",{"$f":"B14*B15","v":{"$error":"#REF!"}},{"$f":"C14*C15","v":{"$error":"#REF!"}},{"$f":"D14*D15","v":{"$error":"#REF!"}},0]
["Installation cost of Charging Infra (₹)",{"$f":"(B13+B16)*20/100","v":{"$error":"#REF!"}},{"$f":"(C13+C16)*20/100","v":{"$error":"#REF!"}},{"$f":"(D13+D16)*20/100","v":{"$error":"#REF!"}},0]
["Total incentive for Charging Infra (₹)",0,0,0,0]
["Total Cost of Charging Infra (Rs.)",{"$f":"(B13+B16+B17)-B18","v":{"$error":"#REF!"}},{"$f":"(C13+C16+C17)-C18","v":{"$error":"#REF!"}},{"$f":"(D13+D16+D17)-D18","v":{"$error":"#REF!"}},0]
[]
[]
["Per Km Capital Cost",{"$f":"(B8+B19)/Summary!$B$4","v":{"$error":"#REF!"}},{"$f":"(C8+C19)/Summary!$B$4","v":{"$error":"#REF!"}},{"$f":"(D8+D19)/Summary!$B$4","v":{"$error":"#REF!"}},{"$f":"(E8+E19)/Summary!$B$4","v":3.1269814350371039}]
[]
["PURCHASE COST"]
["INR",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$25,'2-Wheelers TCO Dashboard'!C20,)","v":59889},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$25,'2-Wheelers TCO Dashboard'!D20,)","v":81998},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$25,'2-Wheelers TCO Dashboard'!E20,)","v":142190},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$25,'2-Wheelers TCO Dashboard'!F20,)","v":66271}]
["USD",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$26,'2-Wheelers TCO Dashboard'!C20*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$26,'2-Wheelers TCO Dashboard'!D20*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$26,'2-Wheelers TCO Dashboard'!E20*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$26,'2-Wheelers TCO Dashboard'!F20*Currency!$C$5,)","v":0}]
["EURO",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$27,'2-Wheelers TCO Dashboard'!C20*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$27,'2-Wheelers TCO Dashboard'!D20*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$27,'2-Wheelers TCO Dashboard'!E20*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$27,'2-Wheelers TCO Dashboard'!F20*Currency!$C$8,)","v":0}]
[]
["TAX"]
["INR",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$30,'2-Wheelers TCO Dashboard'!C21,)","v":4192},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$30,'2-Wheelers TCO Dashboard'!D21,)","v":4549},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$30,'2-Wheelers TCO Dashboard'!E21,)","v":9055},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$30,'2-Wheelers TCO Dashboard'!F21,)","v":4638}]
["USD",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$31,'2-Wheelers TCO Dashboard'!C21*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$31,'2-Wheelers TCO Dashboard'!D21*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$31,'2-Wheelers TCO Dashboard'!E21*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$31,'2-Wheelers TCO Dashboard'!F21*Currency!$C$5,)","v":0}]
["EURO",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$32,'2-Wheelers TCO Dashboard'!C21*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$32,'2-Wheelers TCO Dashboard'!D21*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$32,'2-Wheelers TCO Dashboard'!E21*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$32,'2-Wheelers TCO Dashboard'!F21*Currency!$C$8,)","v":0}]
[]
["INSURANCE"]
["INR",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$35,'2-Wheelers TCO Dashboard'!C22,)","v":1593},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$35,'2-Wheelers TCO Dashboard'!D22,)","v":1680},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$35,'2-Wheelers TCO Dashboard'!E22,)","v":2505},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$35,'2-Wheelers TCO Dashboard'!F22,)","v":4418}]
["USD",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$36,'2-Wheelers TCO Dashboard'!C22*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$36,'2-Wheelers TCO Dashboard'!D22*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$36,'2-Wheelers TCO Dashboard'!E22*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$36,'2-Wheelers TCO Dashboard'!F22*Currency!$C$5,)","v":0}]
["EURO",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$32,'2-Wheelers TCO Dashboard'!C22*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$32,'2-Wheelers TCO Dashboard'!D22*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$32,'2-Wheelers TCO Dashboard'!E22*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Capital Cost'!$A$32,'2-Wheelers TCO Dashboard'!F22*Currency!$C$8,)","v":0}]
[]
["INCENTIVE"]
["INR",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$40,'2-Wheelers TCO Dashboard'!C23,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$40,'2-Wheelers TCO Dashboard'!D23,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$40,'2-Wheelers TCO Dashboard'!E23,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$40,'2-Wheelers TCO Dashboard'!F23,)","v":0}]
["USD",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$41,'2-Wheelers TCO Dashboard'!C23*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$41,'2-Wheelers TCO Dashboard'!D23*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$41,'2-Wheelers TCO Dashboard'!E23*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$41,'2-Wheelers TCO Dashboard'!F23*Currency!$C$5,)","v":0}]
["EURO",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$42,'2-Wheelers TCO Dashboard'!C23*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$42,'2-Wheelers TCO Dashboard'!D23*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$42,'2-Wheelers TCO Dashboard'!E23*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=$A$42,'2-Wheelers TCO Dashboard'!F23*Currency!$C$8,)","v":0}]

{"sheet":"Financing","index":5,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":true,"merged":[[20,0,20,4],[25,0,25,4]]}
["Vehicle Cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["Total Cost of 2W (₹)",{"$f":"'2-Wheelers TCO Dashboard'!C20-'2-Wheelers TCO Dashboard'!C23","v":59889},{"$f":"'2-Wheelers TCO Dashboard'!D20-'2-Wheelers TCO Dashboard'!D23","v":81998},{"$f":"'2-Wheelers TCO Dashboard'!E20-'2-Wheelers TCO Dashboard'!E23","v":142190},{"$f":"'2-Wheelers TCO Dashboard'!F20","v":66271}]
["Share of Operator (%)",{"$f":"100%-B6","v":0.85},{"$f":"100%-C6","v":0.85},{"$f":"100%-D6","v":0.85},{"$f":"100%-E6","v":0.85}]
["Share of Operator (₹)",{"$f":"B3*B2","v":50905.65},{"$f":"C3*C2","v":69698.3},{"$f":"D3*D2","v":120861.5},{"$f":"E3*E2","v":56330.35}]
["Processing  Fees",{"$f":"IF(B8=0,0,IF(B4*0.5%>500,B4*0.5%,500))","v":500},{"$f":"IF(C8=0,0,IF(C4*0.5%>500,C4*0.5%,500))","v":500},{"$f":"IF(D8=0,0,IF(D4*0.5%>500,D4*0.5%,500))","v":604.3075},{"$f":"IF(E8=0,0,IF(E4*0.5%>500,E4*0.5%,500))","v":500}]
["Equity %",{"$f":"'2-Wheelers TCO Dashboard'!C31","v":0.15},{"$f":"'2-Wheelers TCO Dashboard'!D31","v":0.15},{"$f":"'2-Wheelers TCO Dashboard'!E31","v":0.15},{"$f":"'2-Wheelers TCO Dashboard'!F31","v":0.15}]
["Equity (₹)",{"$f":"(B6*B2)","v":8983.35},{"$f":"(C6*C2)","v":12299.699999999999},{"$f":"(D6*D2)","v":21328.5},{"$f":"(E6*E2)","v":9940.65}]
["Loan amount (₹)",{"$f":"B4","v":50905.65},{"$f":"C4","v":69698.3},{"$f":"D4","v":120861.5},{"$f":"E4","v":56330.35}]
["Interest rate (%)",{"$f":"'2-Wheelers TCO Dashboard'!C30","v":0.15},{"$f":"'2-Wheelers TCO Dashboard'!D30","v":0.15},{"$f":"'2-Wheelers TCO Dashboard'!E30","v":0.15},{"$f":"'2-Wheelers TCO Dashboard'!F30","v":0.1}]
["Term of payment (yrs)",{"$f":"'2-Wheelers TCO Dashboard'!C29","v":5},{"$f":"'2-Wheelers TCO Dashboard'!D29","v":5},{"$f":"'2-Wheelers TCO Dashboard'!E29","v":5},{"$f":"'2-Wheelers TCO Dashboard'!F29","v":5}]
["No of EMI (Yearly)",{"$f":"B10*12","v":60},{"$f":"C10*12","v":60},60,60]
["Monthly EMI Loan (Rs.)",{"$f":"((PMT(B9/12,B10*12,-B8))+(B5/B11))","v":1219.3751878339808},{"$f":"((PMT(C9/12,C10*12,-C8))+(C5/C11))","v":1666.4510174713901},{"$f":"((PMT(D9/12,D10*12,-D8))+(D5/D11))","v":2885.3584267991127},{"$f":"((PMT(E9/12,E10*12,-E8))+(E5/E11))","v":1205.1867983847242}]
["Total interest paid",{"$f":"(B12*B10*12)-B8","v":22256.86127003884},{"$f":"(C12*C10*12)-C8","v":30288.761048283413},{"$f":"(D12*D10*12)-D8","v":52260.005607946776},{"$f":"(E12*E10*12)-E8","v":15980.857903083444}]
["Yearly Interest Paid",{"$f":"B13/B10","v":4451.3722540077679},{"$f":"C13/C10","v":6057.7522096566827},{"$f":"D13/D10","v":10452.001121589356},{"$f":"E13/E10","v":3196.171580616689}]
["EMI per KM (Rs.)",{"$f":"B14/Summary!$B$4","v":0.15244425527423863},{"$f":"C14/Summary!$B$4","v":0.20745726745399598},{"$f":"D14/Summary!$B$4","v":0.35794524389004645},{"$f":"E14/Summary!$B$4","v":0.10945793084303729}]
[]
["Total Interest Paid",{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,Financing!$A$22:$E$24,2,0)","v":22256.86127003884},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,Financing!$A$22:$E$24,3,0)","v":30288.761048283413},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,Financing!$A$22:$E$24,4,0)","v":52260.005607946776},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,Financing!$A$22:$E$24,5,0)","v":15980.857903083444}]
["(Used for Dashboard Calc.)"]
[]
[]
["YEARLY INTEREST"]
["INR",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$22,Financing!B13,)","v":22256.86127003884},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$22,Financing!C13,)","v":30288.761048283413},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$22,Financing!D13,)","v":52260.005607946776},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$22,Financing!E13,)","v":15980.857903083444}]
["USD",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$23,Financing!B13*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$23,Financing!C13*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$23,Financing!D13*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$23,Financing!E13*Currency!$C$5,)","v":0}]
["EURO",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$24,Financing!B13*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$24,Financing!C13*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$24,Financing!D13*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15=Financing!$A$24,Financing!E13*Currency!$C$8,)","v":0}]

{"sheet":"Operational Cost","index":6,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":true,"merged":[[33,0,33,4],[38,0,38,4],[43,0,43,4]]}
["Staff cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W",null,"USER INPUT"]
["Staff Cost (₹ / Month)",{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Operational Cost'!$A$35:$B$37,2,0)","v":0},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Operational Cost'!$A$35:$B$37,2,0)","v":0},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Operational Cost'!$A$35:$B$37,2,0)","v":0},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Operational Cost'!$A$35:$B$37,2,0)","v":0},null,"PREFIXED DATA"]
["Other Support staff cost (₹ / Month)",0,0,0,0,null,"CALCULATION"]
["Total Annual Staff Cost (₹)",{"$f":"((B2+B3)*12)","v":0},{"$f":"((C2+C3)*12)","v":0},{"$f":"((D2+D3)*12)","v":0},{"$f":"((E2+E3)*12)","v":0},null,"LINKED CELL"]
["Per km Staff Cost",{"$f":"B4/Summary!$B$4","v":0},{"$f":"C4/Summary!$B$4","v":0},{"$f":"D4/Summary!$B$4","v":0},{"$f":"E4/Summary!$B$4","v":0}]
[]
["Average Fuel Cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["Fuel cost (₹/kWh; ₹/L or $/gal)",{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Operational Cost'!$A$45:$E$47,2,0)","v":6},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Operational Cost'!$A$45:$E$47,3,0)","v":6},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Operational Cost'!$A$45:$E$47,4,0)","v":6},{"$f":"VLOOKUP('2-Wheelers TCO Dashboard'!$C$15,'Operational Cost'!$A$45:$E$47,5,0)","v":100}]
["Mileage (km/kWh; km/L)",{"$f":"'2-Wheelers TCO Dashboard'!C47","v":52},{"$f":"'2-Wheelers TCO Dashboard'!D47","v":57},{"$f":"'2-Wheelers TCO Dashboard'!E47","v":59},{"$f":"'2-Wheelers TCO Dashboard'!F47","v":38}]
["Annual fuel consumption (kWh; L)",{"$f":"Summary!B4/B9","v":561.53846153846155},{"$f":"Summary!B4/C9","v":512.28070175438597},{"$f":"Summary!B4/D9","v":494.91525423728814},{"$f":"Summary!$B$4/E9","v":768.42105263157896}]
["Total Annual Fuel Cost ( ₹ )",{"$f":"(B10*B8)","v":3369.2307692307695},{"$f":"(C10*C8)","v":3073.6842105263158},{"$f":"(D10*D8)","v":2969.4915254237289},{"$f":"(E10*E8)","v":76842.105263157893}]
["Per km Fuel Cost",{"$f":"B11/Summary!$B$4","v":0.11538461538461539},{"$f":"C11/Summary!$B$4","v":0.10526315789473685},{"$f":"D11/Summary!$B$4","v":0.10169491525423729},{"$f":"E11/Summary!$B$4","v":2.6315789473684208}]
[]
["Maintenance Cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["Annual Maintenance Cost (₹)",{"$f":"'2-Wheelers TCO Dashboard'!C48","v":1250},{"$f":"'2-Wheelers TCO Dashboard'!D48","v":1200},{"$f":"'2-Wheelers TCO Dashboard'!E48","v":1200},{"$f":"'2-Wheelers TCO Dashboard'!F48","v":2546}]
["Other Consumables (₹)",0,0,0,0]
["Other Misc. Cost (₹)",1280,1389,2420,1374]
["Total Annual Maintenance cost (₹)",{"$f":"(SUM(B15:B17))","v":2530},{"$f":"(SUM(C15:C17))","v":2589},{"$f":"(SUM(D15:D17))","v":3620},{"$f":"(SUM(E15:E17))","v":3920}]
["Per km Maintenance Cost",{"$f":"B18/Summary!$B$4","v":8.6643835616438361E-2},{"$f":"C18/Summary!$B$4","v":8.8664383561643842E-2},{"$f":"D18/Summary!$B$4","v":0.12397260273972603},{"$f":"E18/Summary!$B$4","v":0.13424657534246576}]
[]
["Battery Replacement Cost","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["Number of  battery replacements ",{"$f":"'2-Wheelers TCO Dashboard'!C46","v":10},{"$f":"'2-Wheelers TCO Dashboard'!D46","v":2},{"$f":"'2-Wheelers TCO Dashboard'!E46","v":1},0]
["Capacity of battery (kWh)",{"$f":"'2-Wheelers TCO Dashboard'!C45","v":3.24},{"$f":"'2-Wheelers TCO Dashboard'!D45","v":1.75},{"$f":"'2-Wheelers TCO Dashboard'!E45","v":2.4},0]
["Battery Cost (₹ / kWh)",{"$f":"Summary!B7*Summary!B8","v":7300},{"$f":"Summary!B6*Summary!B7","v":10001},{"$f":"Summary!B6*Summary!B7","v":10001}]
["Total battery Cost (₹)",{"$f":"B24*B23","v":23652},{"$f":"C24*C23","v":17501.75},{"$f":"D24*D23","v":24002.399999999998},0]
["Battery replacement Charge (₹) ",0,0,0,0]
["Total battery replacement cost (₹)",{"$f":"((B25+B26)*B22)","v":236520},{"$f":"((C25+C26)*C22)","v":35003.5},{"$f":"((D25+D26)*D22)","v":24002.399999999998},0]
["Annual Battery Replacement Cost",{"$f":"B27/Summary!B3","v":23652},{"$f":"C27/Summary!B3","v":3500.35},{"$f":"D27/Summary!B3","v":2400.2399999999998}]
["Per Km Battery Replacement Cost",{"$f":"B27/Summary!$B$5","v":0.81},{"$f":"C27/Summary!$B$5","v":0.119875},{"$f":"D27/Summary!$B$5","v":8.2199999999999995E-2},{"$f":"E27/Summary!$B$5","v":0}]
[]
["Total Operational Cost",{"$f":"B27+B18+B11+B4","v":242419.23076923078},{"$f":"C27+C18+C11+C4","v":40666.184210526313},{"$f":"D27+D18+D11+D4","v":30591.891525423725},{"$f":"E27+E18+E11+E4","v":80762.105263157893}]
["Per Km Operational Cost",{"$f":"B29+B19+B12+B5","v":1.0120284510010538},{"$f":"C29+C19+C12+C5","v":0.3138025414563807},{"$f":"D29+D19+D12+D5","v":0.30786751799396334},{"$f":"E29+E19+E12+E5","v":2.7658255227108866}]
[]
["STAFF COST"]
["INR",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$35,'2-Wheelers TCO Dashboard'!$C$40,)","v":0}]
["USD",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$36,'2-Wheelers TCO Dashboard'!$C$40*Currency!$C$5,)","v":0}]
["EURO",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$37,'2-Wheelers TCO Dashboard'!$C$40*Currency!$C$8,)","v":0}]
[]
["ANNUAL MAINTENANCE COST"]
["INR",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$40,'2-Wheelers TCO Dashboard'!C48,)","v":1250},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$40,'2-Wheelers TCO Dashboard'!D48,)","v":1200},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$40,'2-Wheelers TCO Dashboard'!E48,)","v":1200},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$40,'2-Wheelers TCO Dashboard'!F48,)","v":2546}]
["USD",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$41,'2-Wheelers TCO Dashboard'!C48*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$41,'2-Wheelers TCO Dashboard'!D48*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$41,'2-Wheelers TCO Dashboard'!E48*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$41,'2-Wheelers TCO Dashboard'!F48*Currency!$C$5,)","v":0}]
["EURO",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$42,'2-Wheelers TCO Dashboard'!C48*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$42,'2-Wheelers TCO Dashboard'!D48*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$42,'2-Wheelers TCO Dashboard'!E48*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$42,'2-Wheelers TCO Dashboard'!F48*Currency!$C$8,)","v":0}]
[]
["AVERAGE FUEL COST"]
["INR",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$45,'2-Wheelers TCO Dashboard'!C44,)","v":6},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$45,'2-Wheelers TCO Dashboard'!D44,)","v":6},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$45,'2-Wheelers TCO Dashboard'!E44,)","v":6},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$45,'2-Wheelers TCO Dashboard'!F44,)","v":100}]
["USD",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$46,'2-Wheelers TCO Dashboard'!C44*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$46,'2-Wheelers TCO Dashboard'!D44*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$46,'2-Wheelers TCO Dashboard'!E44*Currency!$C$5,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$46,'2-Wheelers TCO Dashboard'!F44*Currency!$C$5/3.78,)","v":0}]
["EURO",{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$47,'2-Wheelers TCO Dashboard'!C44*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$47,'2-Wheelers TCO Dashboard'!D44*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$47,'2-Wheelers TCO Dashboard'!E44*Currency!$C$8,)","v":0},{"$f":"IF('2-Wheelers TCO Dashboard'!$C$15='Operational Cost'!$A$47,'2-Wheelers TCO Dashboard'!F44*Currency!$C$8,)","v":0}]

{"sheet":"TCO_1","index":7,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["Parameter","Unit","e-2W (VRLA)","e-2W (LIB_SB)","e-2W (LIB_BB)","Petrol-2W"]
["Discount rate value","-",{"$f":"Summary!B10","v":0.1},{"$f":"Summary!C10","v":0.1},{"$f":"Summary!D10","v":0.1},{"$f":"Summary!E10","v":0.1}]
["Resale rate value","-",{"$f":"Summary!B11","v":0.1},{"$f":"Summary!C11","v":0.15},{"$f":"Summary!D11","v":0.2},{"$f":"Summary!E11","v":0.1}]
["Capital recovery factor (CRF)_N","-",{"$f":"C2*(1+C2)^Summary!B3","v":0.2593742460100002},{"$f":"D2*(1+D2)^Summary!B3","v":0.2593742460100002},{"$f":"E2*(1+E2)^Summary!B3","v":0.2593742460100002},{"$f":"F2*(1+F2)^Summary!B3","v":0.2593742460100002}]
["Capital recovery factor (CRF)_D","-",{"$f":"((1+C2)^Summary!B3)-1","v":1.5937424601000019},{"$f":"(1+D2)^Summary!B3-1","v":1.5937424601000019},{"$f":"(1+E2)^Summary!B3-1","v":1.5937424601000019},{"$f":"(1+F2)^Summary!B3-1","v":1.5937424601000019}]
["CRF","-",{"$f":"C4/C5","v":0.16274539488251155},{"$f":"D4/D5","v":0.16274539488251155},{"$f":"E4/E5","v":0.16274539488251155},{"$f":"F4/F5","v":0.16274539488251155}]
["Present value factor (PVF)","-",{"$f":"1/(1+C2)^10","v":0.38554328942953148},{"$f":"1/(1+D2)^Summary!B3","v":0.38554328942953148},{"$f":"1/(1+E2)^Summary!B3","v":0.38554328942953148},{"$f":"1/(1+F2)^Summary!B3","v":0.38554328942953148}]
["Residual value (RV)","₹",{"$f":"Summary!B14*C3","v":8793.0861270038858},{"$f":"Summary!C14*D3","v":17777.364157242511},{"$f":"Summary!D14*E3","v":41202.001121589361},{"$f":"Summary!E14*F3","v":9130.7857903083441}]
["Annual  Travel Distance","km",{"$f":"Summary!$B$4","v":29200},{"$f":"Summary!$B$4","v":29200},{"$f":"Summary!$B$4","v":29200},{"$f":"Summary!$B$4","v":29200}]
["Capex component","₹",{"$f":"((Summary!B19-(C8*C7))*C6)","v":13758.61707847702},{"$f":"(Summary!C19-(D8*D7))*D6","v":18172.446597587877},{"$f":"(Summary!D19-(E8*E7))*E6","v":30941.943882089909},{"$f":"(Summary!E19-(F8*F7))*F6","v":14287.018630313045}]
["TCO","₹/km",{"$f":"(C10+L22)/C9","v":1.0930331893920329},{"$f":"(D10+L23)/D9","v":0.81516213895316914},{"$f":"(E10+L24)/E9","v":1.2488268747984046},{"$f":"(F10+L25)/F9","v":2.1887615126390045}]
[]
["Opex / year"]
["Vehicle type","Unit",1,{"$f":"C14+1","v":2},3,4,5,6,7,8,9,10,"Total"]
["e-2W (VRLA)","₹",{"$f":"Summary!$B$27/(1+$C$2)^C14","v":26864.755244755244},{"$f":"Summary!$B$27/(1+$C$2)^D14","v":24422.504767959308},{"$f":"Summary!$B$27/(1+$C$2)^E14","v":22202.277061781188},{"$f":"Summary!$B$27/(1+$C$2)^F14","v":20183.888237982897},{"$f":"Summary!$B$27/(1+$C$2)^G14","v":18348.989307257179},{"$f":"Summary!$B$27/(1+$C$2)^H14","v":16680.899370233798},{"$f":"Summary!$B$27/(1+$C$2)^I14","v":15164.453972939813},{"$f":"Summary!$B$27/(1+$C$2)^J14","v":13785.867248127104},{"$f":"Summary!$B$27/(1+$C$2)^K14","v":12532.606589206458},{"$f":"Summary!$B$27/(1+$C$2)^L14","v":11393.278717460415},{"$f":"SUM(C15:L15)/Summary!B3","v":18157.952051770339}]
["e-2W (LIB_SB)","₹",{"$f":"Summary!$C$27/(1+$D$2)^C14","v":8330.0311004784671},{"$f":"Summary!$C$27/(1+$D$2)^D14","v":7572.7555458895158},{"$f":"Summary!$C$27/(1+$D$2)^E14","v":6884.3232235359219},{"$f":"Summary!$C$27/(1+$D$2)^F14","v":6258.4756577599292},{"$f":"Summary!$C$27/(1+$D$2)^G14","v":5689.5233252362996},{"$f":"Summary!$C$27/(1+$D$2)^H14","v":5172.2939320329988},{"$f":"Summary!$C$27/(1+$D$2)^I14","v":4702.0853927572707},{"$f":"Summary!$C$27/(1+$D$2)^J14","v":4274.6230843247922},{"$f":"Summary!$C$27/(1+$D$2)^K14","v":3886.0209857498107},{"$f":"Summary!$C$27/(1+$D$2)^L14","v":3532.7463506816457},{"$f":"SUM(C16:L16)/Summary!B3","v":5630.2878598446641}]
["e-2W (LIB_BB)","₹",{"$f":"Summary!$D$27/(1+$E$2)^C14","v":8172.4832049306624},{"$f":"Summary!$D$27/(1+$E$2)^D14","v":7429.5301863006016},{"$f":"Summary!$D$27/(1+$E$2)^E14","v":6754.1183511823638},{"$f":"Summary!$D$27/(1+$E$2)^F14","v":6140.1075919839677},{"$f":"Summary!$D$27/(1+$E$2)^G14","v":5581.9159927126975},{"$f":"Summary!$D$27/(1+$E$2)^H14","v":5074.4690842842692},{"$f":"Summary!$D$27/(1+$E$2)^I14","v":4613.1537129856988},{"$f":"Summary!$D$27/(1+$E$2)^J14","v":4193.7761027142724},{"$f":"Summary!$D$27/(1+$E$2)^K14","v":3812.5237297402473},{"$f":"Summary!$D$27/(1+$E$2)^L14","v":3465.9306634002241},{"$f":"SUM(C17:L17)/Summary!B3","v":5523.8008620235005}]
["Petrol-2W","₹",{"$f":"Summary!$E$27/(1+$F$2)^C14","v":73420.095693779891},{"$f":"Summary!$E$27/(1+$F$2)^D14","v":66745.541539799902},{"$f":"Summary!$E$27/(1+$F$2)^E14","v":60677.765036181721},{"$f":"Summary!$E$27/(1+$F$2)^F14","v":55161.604578347018},{"$f":"Summary!$E$27/(1+$F$2)^G14","v":50146.913253042745},{"$f":"Summary!$E$27/(1+$F$2)^H14","v":45588.102957311574},{"$f":"Summary!$E$27/(1+$F$2)^I14","v":41443.729961192337},{"$f":"Summary!$E$27/(1+$F$2)^J14","v":37676.118146538494},{"$f":"Summary!$E$27/(1+$F$2)^K14","v":34251.016496853168},{"$f":"Summary!$E$27/(1+$F$2)^L14","v":31137.28772441197},{"$f":"SUM(C18:L18)/Summary!B3","v":49624.817538745883}]
[]
["Opex Sum"]
["Vehicle type","Unit",1,{"$f":"C21+1","v":2},3,4,5,6,7,8,9,10]
["e-2W (VRLA)","₹/km",{"$f":"(1/C21)*SUM($C$15:C15)","v":26864.755244755244},{"$f":"(1/D21)*SUM($C$15:D15)","v":25643.630006357278},{"$f":"(1/E21)*SUM($C$15:E15)","v":24496.512358165248},{"$f":"(1/F21)*SUM($C$15:F15)","v":23418.356328119662},{"$f":"(1/G21)*SUM($C$15:G15)","v":22404.482923947166},{"$f":"(1/H21)*SUM($C$15:H15)","v":21450.552331661602},{"$f":"(1/I21)*SUM($C$15:I15)","v":20552.538280415629},{"$f":"(1/J21)*SUM($C$15:J15)","v":19706.704401379564},{"$f":"(1/K21)*SUM($C$15:K15)","v":18909.582422249219},{"$f":"(1/L21)*SUM($C$15:L15)","v":18157.952051770339}]
["e-2W (LIB_SB)","₹/km",{"$f":"(1/C21)*SUM($C$16:C16)","v":8330.0311004784671},{"$f":"(1/D21)*SUM($C$16:D16)","v":7951.393323183991},{"$f":"(1/E21)*SUM($C$16:E16)","v":7595.7032899679671},{"$f":"(1/F21)*SUM($C$16:F16)","v":7261.396381915958},{"$f":"(1/G21)*SUM($C$16:G16)","v":6947.021770580026},{"$f":"(1/H21)*SUM($C$16:H16)","v":6651.2337974888542},{"$f":"(1/I21)*SUM($C$16:I16)","v":6372.7840253843415},{"$f":"(1/J21)*SUM($C$16:J16)","v":6110.5139077518979},{"$f":"(1/K21)*SUM($C$16:K16)","v":5863.3480275294432},{"$f":"(1/L21)*SUM($C$16:L16)","v":5630.2878598446641}]
["e-2W (LIB_BB)","₹/km",{"$f":"(1/C21)*SUM($C$17:C17)","v":8172.4832049306624},{"$f":"(1/D21)*SUM($C$17:D17)","v":7801.0066956156315},{"$f":"(1/E21)*SUM($C$17:E17)","v":7452.0439141378756},{"$f":"(1/F21)*SUM($C$17:F17)","v":7124.0598335993991},{"$f":"(1/G21)*SUM($C$17:G17)","v":6815.6310654220597},{"$f":"(1/H21)*SUM($C$17:H17)","v":6525.4374018990939},{"$f":"(1/I21)*SUM($C$17:I17)","v":6252.2540177686078},{"$f":"(1/J21)*SUM($C$17:J17)","v":5994.9442783868162},{"$f":"(1/K21)*SUM($C$17:K17)","v":5752.4531063149752},{"$f":"(1/L21)*SUM($C$17:L17)","v":5523.8008620235014}]
["Petrol-2W","₹/km",{"$f":"(1/C21)*SUM($C$18:C18)","v":73420.095693779891},{"$f":"(1/D21)*SUM($C$18:D18)","v":70082.818616789897},{"$f":"(1/E21)*SUM($C$18:E18)","v":66947.800756587167},{"$f":"(1/F21)*SUM($C$18:F18)","v":64001.251712027137},{"$f":"(1/G21)*SUM($C$18:G18)","v":61230.38402023026},{"$f":"(1/H21)*SUM($C$18:H18)","v":58623.337176410467},{"$f":"(1/I21)*SUM($C$18:I18)","v":56169.107574236448},{"$f":"(1/J21)*SUM($C$18:J18)","v":53857.48389577421},{"$f":"(1/K21)*SUM($C$18:K18)","v":51678.987518116308},{"$f":"(1/L21)*SUM($C$18:L18)","v":49624.817538745883}]
[]
["TCO / year"]
["Vehicle type","Unit",1,{"$f":"C28+1","v":2},3,4,5,6,7,8,9,10,"Average TCO"]
["PVF","-",{"$f":"1/(1+$C$2)^C28","v":0.90909090909090906},{"$f":"1/(1+$C$2)^D28","v":0.82644628099173545},0.75131480090157754,0.68301345536507052,0.62092132305915493,0.56447393005377722,0.51315811823070645,0.46650738020973315,0.42409761837248466,0.38554328942953148]
["CRF","-",{"$f":"($C$2*(1+$C$2)^C28)/((1+$C$2)^C28-1)","v":1.0999999999999992},{"$f":"($C$2*(1+$C$2)^D28)/((1+$C$2)^D28-1)","v":0.57619047619047581},0.40211480362537733,0.31547080370609765,0.26379748079474524,0.22960738036266726,0.20540549970059557,0.18744401757481335,0.1736405390743434,0.16274539488251155]
["e-2W (VRLA)","₹/km",{"$f":"(((Summary!$B$19-($C$8*C29))*C30)+C22)/($C$9)","v":3.9313567299586998},{"$f":"(((Summary!$B$19-($C$8*D29))*D30)+D22)/($C$9)","v":2.4699099644992391},{"$f":"(((Summary!$B$19-($C$8*E29))*E30)+E22)/($C$9)","v":1.9588456123923428},{"$f":"(((Summary!$B$19-($C$8*F29))*F30)+F22)/($C$9)","v":1.6871000845447166},{"$f":"(((Summary!$B$19-($C$8*G29))*G30)+G22)/($C$9)","v":1.5123334676397666},{"$f":"(((Summary!$B$19-($C$8*H29))*H30)+H22)/($C$9)","v":1.3870026774891799},{"$f":"(((Summary!$B$19-($C$8*I29))*I30)+I22)/($C$9)","v":1.2906568884097427},{"$f":"(((Summary!$B$19-($C$8*J29))*J30)+J22)/($C$9)","v":1.2130108057815967},{"$f":"(((Summary!$B$19-($C$8*K29))*K30)+K22)/($C$9)","v":1.148301951093506},{"$f":"(((Summary!$B$19-($C$8*L29))*L30)+L22)/($C$9)","v":1.0930331893920329},{"$f":"SUM(C31:L31)/$L$28","v":1.7691551371200824}]
["PVF","-",{"$f":"1/(1+$D$2)^C28","v":0.90909090909090906},{"$f":"1/(1+$D$2)^D28","v":0.82644628099173545},0.75131480090157754,0.68301345536507052,0.62092132305915493,0.56447393005377722,0.51315811823070645,0.46650738020973315,0.42409761837248466,0.38554328942953148]
["CRF","-",{"$f":"($D$2*(1+$D$2)^C28)/((1+$D$2)^C28-1)","v":1.0999999999999992},{"$f":"($D$2*(1+$D$2)^D28)/((1+$D$2)^D28-1)","v":0.57619047619047581},0.40211480362537733,0.31547080370609765,0.26379748079474524,0.22960738036266726,0.20540549970059557,0.18744401757481335,0.1736405390743434,0.16274539488251155]
["e-2W (LIB_SB)","₹/km",{"$f":"(((Summary!$C$19-($D$8*C32))*C33)+C23)/($D$9)","v":4.1410960306968372},{"$f":"(((Summary!$C$19-($D$8*D32))*D33)+D23)/($D$9)","v":2.321014884048707},{"$f":"(((Summary!$C$19-($D$8*E32))*E33)+E23)/($D$9)","v":1.7082822051050839},{"$f":"(((Summary!$C$19-($D$8*F32))*F33)+F23)/($D$9)","v":1.3979162955109841},{"$f":"(((Summary!$C$19-($D$8*G32))*G33)+G23)/($D$9)","v":1.2088799145706186},{"$f":"(((Summary!$C$19-($D$8*H32))*H33)+H23)/($D$9)","v":1.0807962200445094},{"$f":"(((Summary!$C$19-($D$8*I32))*I33)+I23)/($D$9)","v":0.98776510936814288},{"$f":"(((Summary!$C$19-($D$8*J32))*J33)+J23)/($D$9)","v":0.9168171287937994},{"$f":"(((Summary!$C$19-($D$8*K32))*K33)+K23)/($D$9)","v":0.86073130085271221},{"$f":"(((Summary!$C$19-($D$8*L32))*L33)+L23)/($D$9)","v":0.81516213895316914},{"$f":"SUM(C34:L34)/$L$28","v":1.5438461227944562}]
["PVF","-",{"$f":"1/(1+$E$2)^C28","v":0.90909090909090906},{"$f":"1/(1+$E$2)^D28","v":0.82644628099173545},0.75131480090157754,0.68301345536507052,0.62092132305915493,0.56447393005377722,0.51315811823070645,0.46650738020973315,0.42409761837248466,0.38554328942953148]
["CRF","-",{"$f":"($E$2*(1+$E$2)^C28)/((1+$E$2)^C28-1)","v":1.0999999999999992},{"$f":"($E$2*(1+$E$2)^D28)/((1+$E$2)^D28-1)","v":0.57619047619047581},0.40211480362537733,0.31547080370609765,0.26379748079474524,0.22960738036266726,0.20540549970059557,0.18744401757481335,0.1736405390743434,0.16274539488251155]
["e-2W (LIB_BB)","₹/km",{"$f":"(((Summary!$D$19-($E$8*C35))*C36)+C24)/($E$9)","v":6.6295030223315967},{"$f":"(((Summary!$D$19-($E$8*D35))*D36)+D24)/($E$9)","v":3.6603427874236623},{"$f":"(((Summary!$D$19-($E$8*E35))*E36)+E24)/($E$9)","v":2.6658898077472171},{"$f":"(((Summary!$D$19-($E$8*F35))*F36)+F24)/($E$9)","v":2.1656292321324537},{"$f":"(((Summary!$D$19-($E$8*G35))*G36)+G24)/($E$9)","v":1.8634166978044915},{"$f":"(((Summary!$D$19-($E$8*H35))*H36)+H24)/($E$9)","v":1.6605058796907284},{"$f":"(((Summary!$D$19-($E$8*I35))*I36)+I24)/($E$9)","v":1.5145522139077323},{"$f":"(((Summary!$D$19-($E$8*J35))*J36)+J24)/($E$9)","v":1.4043636602724812},{"$f":"(((Summary!$D$19-($E$8*K35))*K36)+K24)/($E$9)","v":1.3181508205908157},{"$f":"(((Summary!$D$19-($E$8*L35))*L36)+L24)/($E$9)","v":1.2488268747984046},{"$f":"SUM(C37:L37)/$L$28","v":2.4131180996699579}]
["PVF","-",{"$f":"1/(1+$F$2)^C28","v":0.90909090909090906},{"$f":"1/(1+$F$2)^D28","v":0.82644628099173545},0.75131480090157754,0.68301345536507052,0.62092132305915493,0.56447393005377722,0.51315811823070645,0.46650738020973315,0.42409761837248466,0.38554328942953148]
["CRF","-",{"$f":"($F$2*(1+$F$2)^C28)/((1+$F$2)^C28-1)","v":1.0999999999999992},{"$f":"($F$2*(1+$F$2)^D28)/((1+$F$2)^D28-1)","v":0.57619047619047581},0.40211480362537733,0.31547080370609765,0.26379748079474524,0.22960738036266726,0.20540549970059557,0.18744401757481335,0.1736405390743434,0.16274539488251155]
["Petrol-2W","₹/km",{"$f":"(((Summary!$E$19-($F$8*C38))*C39)+C25)/($F$9)","v":5.6413682738651802},{"$f":"(((Summary!$E$19-($F$8*D38))*D39)+D25)/($F$9)","v":4.0529295722061534},{"$f":"(((Summary!$E$19-($F$8*E38))*E39)+E25)/($F$9)","v":3.4556676900943502},{"$f":"(((Summary!$E$19-($F$8*F38))*F39)+F25)/($F$9)","v":3.1109177149551055},{"$f":"(((Summary!$E$19-($F$8*G38))*G39)+G25)/($F$9)","v":2.8706016164965504},{"$f":"(((Summary!$E$19-($F$8*H38))*H39)+H25)/($F$9)","v":2.6850985619564929},{"$f":"(((Summary!$E$19-($F$8*I38))*I39)+I25)/($F$9)","v":2.5329386546069772},{"$f":"(((Summary!$E$19-($F$8*J38))*J39)+J25)/($F$9)","v":2.4032247611013275},{"$f":"(((Summary!$E$19-($F$8*K38))*K39)+K25)/($F$9)","v":2.2897718218616645},{"$f":"(((Summary!$E$19-($F$8*L38))*L39)+L25)/($F$9)","v":2.1887615126390045},{"$f":"SUM(C40:L40)/$L$28","v":3.1231280179782805}]
[]
["USER INPUT"]
["PREFIXED DATA"]
["CALCULATION"]
["LINKED CELL"]

{"sheet":"References","index":8,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Assumption",null,null,null,"Source"]
[1,"Life of Vehicle",null,null,null,"Assumed"]
[2,"Annual driving distance",null,null,null,"Base case assumption = 5000 km per year"]
[3,"Total distance travelled",null,null,null,"Assumed"]
[4,"LIB cost",null,null,null,"https://bnef.turtl.co/story/evo2018?teaser=true ",null,null,null,null,"BNEF EV Outlook 2018 ($200/kWh)"]
[5,"Pb-Acid battery cost",null,null,null,"https://www.engineering.com/ElectronicsDesign/ElectronicsDesignArticles/ArticleID/17776/NantEnergys-Zinc-Air-Battery-Crosses-the-100kWh-Barrier.aspx"]
[6,"Discount rate",null,null,null,"Assumed"]
[7,"Resale value",null,null,null,"Assumed"]
[8,"Purchase cost (VRLA)",null,null,null,"https://auto.ndtv.com/okinawa-bikes/praise"]
[9,"Purchase cost (LIB_SB)",null,null,null,"https://auto.ndtv.com/okinawa-bikes/ridge-plus"]
[10,"Purchase cost (LIB_BB)",null,null,null,"https://auto.ndtv.com/ather-bikes/450"]
[11,"Purchase cost (Petrol)",null,null,null,"https://auto.ndtv.com/honda-bikes/activa-125 "]
[12,"Tax (VRLA)",null,null,null,"https://auto.ndtv.com/okinawa-bikes/praise"]
[13,"Tax (LIB_SB)",null,null,null,"https://auto.ndtv.com/okinawa-bikes/ridge-plus"]
[14,"Tax (LIB_BB)",null,null,null,"https://auto.ndtv.com/ather-bikes/450"]
[15,"Tax (Petrol)",null,null,null,"https://auto.ndtv.com/honda-bikes/activa-125 "]
[16,"Insurance (VRLA)",null,null,null,"https://auto.ndtv.com/okinawa-bikes/praise"]
[17,"Insurance (LIB_SB)",null,null,null,"https://auto.ndtv.com/okinawa-bikes/ridge-plus"]
[18,"Insurance (LIB_BB)",null,null,null,"https://auto.ndtv.com/ather-bikes/450"]
[19,"Insurance (Petrol)",null,null,null,"https://auto.ndtv.com/honda-bikes/activa-125 "]
[20,"Fuel cost for e-2W",null,null,null,"http://transport.delhi.gov.in/sites/default/files/All-PDF/Electric%20Policy%202018.pdf"]
[21,"Fuel cost for petrol-2W",null,null,null,"https://www.iocl.com/Product_PreviousPrice/PetrolPreviousPriceDynamic.aspx"]
[22,"Mileage (VRLA)",null,null,null,"https://auto.ndtv.com/okinawa-bikes/praise",null,null,null,null,"Battery capacity: 72V/45Ah (=3.24kWh); Range: 170km/charge ; Mileage = 52 km/kWh"]
[23,"Mileage (LIB_SB)",null,null,null,"http://okinawascooters.com/ridge-plus/",null,null,null,null,"Battery capacity: 1.75kWh; Range = 100km/charge; Mileage = 57 km/kWh"]
[24,"Mileage (LIB_BB)",null,null,null,"https://auto.ndtv.com/ather-bikes/450",null,null,null,null,"Battery capacity: 2.4kWh; Range = 75km/charge; Mileage = 31 km/kWh"]
[25,"Mileage (Petrol)",null,null,null,"https://auto.ndtv.com/honda-bikes/activa-125",null,null,null,null,"59km/L"]
[26,"Annual maintenance cost (petrol)",null,null,null,"https://droom.in/honda-scootermodels/activa125/cost-of-ownership?kms=900",null,null,null,null,null,null,null,"Tyre change cost+Service cost"]
[27,"Misc. Cost (VRLA)",null,null,null,"https://droom.in/okinawa-scootermodels/ridge-plus/cost-of-ownership?kms=417"]
[28,"Misc. Cost (LIB_SB)",null,null,null,"https://droom.in/okinawa-scootermodels/ridge-plus/cost-of-ownership?kms=417"]
[29,"Misc. Cost (LIB_BB)",null,null,null,"https://droom.in/okinawa-scootermodels/ridge-plus/cost-of-ownership?kms=417"]
[30,"Misc. Cost (Petrol)",null,null,null,"https://droom.in/honda-scootermodels/activa125/cost-of-ownership?kms=900"]
[31,"No. of battery replacements (VRLA)",null,null,null,"For 5K AKT = 2 battery replacement; For 10K AKT = 3 battery replacement (assumption)"]
[32,"No. of battery replacements (LIB_BB)",null,null,null,"1 battery replacement after 5 years (assumption)"]
[33,"No. of battery replacements (LIB_SB)",null,null,null,"1 battery replacement after 5 years (assumption)"]
[34,"Battery capacity (VRLA)",null,null,null,"https://auto.ndtv.com/okinawa-bikes/praise"]
[35,"Battery capacity (LIB_SB)",null,null,null,"http://okinawascooters.com/ridge-plus/"]
[36,"Battery capacity (LIB_BB)",null,null,null,"https://auto.ndtv.com/ather-bikes/450"]
[37,"Financing Cost terms",null,null,null,"https://www.bankbazaar.com/two-wheeler-loan.html"]

{"sheet":"Tech. Specs.","index":9,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Specifications","Okinawa Praise","Okinawa Ridge Plus","Ather 450","Honda Activa 125"]
[null,"Engine","BLDC Motor","BLDC Motor","BLDC Motor","124.9 CC"]
[null,"Max Speed","75 kmph","55 kmph","80 kmph"]
[null,"Rated Power","1000 Watt","800 Watt","5.4 kW"]
[null,"Battery Type","VRLA","Li-ion","Li-ion"]
[null,"Battery Capacity","3.24 kWh","1.75 kWh","2.4 kWh Lithium-ion "]
[null,"Battery Range","170 Km/charge","100 km/charge","75 km/charge"]
[null,"Charging Time","6-8 hrs","2-3 hrs","2 - 2.5 hrs"]
[null,"Cycle life (Battery)"]